import pandas as pd
import numpy as np


filename = 'data/cleaned_data.csv'
df = pd.read_csv(filename, low_memory=False)


#show df rows where Year is 2022
print(df[df['Year'] == 2022])

#group by Town Name rank by the number of rows in each group
print(df.groupby('Town Name').size().sort_values(ascending=False))